package com.ysd.lis.request;

import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import java.sql.Timestamp;
import java.time.LocalDateTime;

/**
 * <p>
 * 核算结果-Sql记录表
 * </p>
 *
 * @author LiuQi
 * @since 2024-04-25
 */
@Data
public class WkCalcResultSqlDto {

    private String id;
    private String elementId;
    private String formulaId;
    private String formulaCode;
    private String formulaName;
    private Integer formulaIndex;
    private String userId;
    private String userCode;
    private String userName;
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    @JsonFormat(pattern = "yyyy-MM-dd",timezone="GMT+8")
    private Timestamp startDate;
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    @JsonFormat(pattern = "yyyy-MM-dd",timezone="GMT+8")
    private Timestamp endDate;
    private String formula;
    private String result;
    private String sqlValue;

    // database 表字段
    private String databaseName;
    private String databaseCode;
    private Long databaseType;
    private String host;
    private String port;
    private String dataUsername;
    private String password;
    private String dbName;



}
